﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Transfer_Object_Tier;
using System.Data;

namespace Interface_Tier
{
    public interface INhanVien
    {
        int NHAN_VIEN_THEM(HRM_EMPLOYEE NHAN_VIEN);
        int NHAN_VIEN_CAP_NHAT(HRM_EMPLOYEE NHAN_VIEN);
        int NHAN_VIEN_CAP_NHAT_HOP_DONG(HRM_EMPLOYEE NHAN_VIEN);
        int NHAN_VIEN_CAP_NHAT_MA_CHAM_CONG(string MA_CHAM_CONG, string MA_NHAN_VIEN);
        int NHAN_VIEN_XOA(string MA_NV);

        DataSet LAY_DS_NHAN_VIEN_THEO_TINH_TRANG(int TINH_TRANG, DateTime NGAY_BAT_DAU_CUA_THANG, DateTime NGAY_CUOI_CUNG_CUA_THANG);
        DataSet LAY_TOAN_BO_DS_NHAN_VIEN();

        DataSet LAY_THONG_TIN_NHAN_VIEN(string MA_NV);
        DataSet LAY_THONG_TIN_NHAN_VIEN_THEO_MA_CHAM_CONG(string MA_CHAM_CONG);

        int LAY_SL_NHAN_VIEN();
        DataSet THONG_KE_NHAN_VIEN_THEO_DO_TUOI();
        DataSet THONG_KE_NHAN_VIEN_THEO_GIOI_TINH();
        DataSet THONG_KE_NHAN_VIEN_THEO_TRINH_DO();
        DataSet THONG_KE_NHAN_VIEN_THEO_DAN_TOC();
        DataSet THONG_KE_NHAN_VIEN_THEO_HON_NHAN();
        DataSet THONG_KE_NHAN_VIEN_THEO_NUOC();
        DataSet THONG_KE_TONG_QUAN();
        DataSet THONG_KE_TINH_TRANG_LAM_VIEC();
        DataSet THONG_KE_NHAN_VIEN_THEO_TON_GIAO();
        DataSet THONG_KE_NHAN_VIEN_THEO_VI_TRI_CONG_VIEC();
        DataSet THONG_KE_GIA_TANG_SL_NHAN_VIEN_THEO_NAM(string TU_NAM, string DEN_NAM);


        DataSet LAY_DS_NHAN_VIEN_THEO_NGAY_SINH_HOM_NAY();
        DataSet LAY_DS_NHAN_VIEN_THEO_THANG_SINH(string THANG);
        DataSet LAY_DS_NHAN_VIEN_THEO_CHI_NHANH(string MA_CHI_NHANH, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG);
        DataSet LAY_DS_NHAN_VIEN_THEO_PHONG_BAN(string MA_PHONG_BAN, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG);
        DataSet LAY_DS_NHAN_VIEN_THEO_TO_NHOM(string MA_TO_NHOM, string TINH_TRANG, string NGAY_BAT_DAU_CUA_THANG, string NGAY_CUOI_CUNG_CUA_THANG);
        DataSet LAY_DS_NHAN_VIEN_THEO_NAM(string NAM);
        DataSet HRM_EMPLOYEE_Count();
        DataSet HRM_EMPLOYEE_GetAge();
        DataSet HRM_EMPLOYEE_GetAllSex();
        DataSet HRM_EMPLOYEE_GetByEnroll(string EnrollNumber);
        DataSet HRM_EMPLOYEE_GetEducation();
        DataSet HRM_EMPLOYEE_GetEthnic();
        DataSet HRM_EMPLOYEE_GetIncreaseDecreaseList(int Level, string Code, int Status, int Month, int Year);
        DataSet HRM_EMPLOYEE_GetListBirthday();
        DataSet HRM_EMPLOYEE_GetListBirthdayByMonth(int Month);
        DataSet HRM_EMPLOYEE_GetListByBranch(string BranchCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth);
        DataSet HRM_EMPLOYEE_GetListByDepartment(string DepartmentCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth);
        DataSet HRM_EMPLOYEE_GetListByGroup(string GroupCode, int Status, DateTime DayFirstMonth, DateTime DayEndMonth);
        DataSet HRM_EMPLOYEE_GetListByYear(int Year);
        DataSet HRM_EMPLOYEE_GetMarriage();
        DataSet HRM_EMPLOYEE_GetNationality();
        DataSet HRM_EMPLOYEE_GetPosition();
        DataSet HRM_EMPLOYEE_GetRate(int FromYear, int ToYear);
        DataSet HRM_EMPLOYEE_GetReligion();
        DataSet HRM_EMPLOYEE_GetSex();
        DataSet HRM_EMPLOYEE_GetStatistical();
        DataSet HRM_EMPLOYEE_GetStatus();



















      


    }
}
